---
title: clsClaimWorkReleaseStatus
summary: API reference for clsClaimWorkReleaseStatus.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-21
library: SAIF.Business.Claim
reference_type: embedded
---

# clsClaimWorkReleaseStatus

`clsClaimWorkReleaseStatus` owns a work-release-status history row for a claim, retrieving only the latest row via a correlated `max(seq)` subquery and enforcing level-two date validation.

## Purpose
- Provides full create/retrieve/update/delete of work-release-status rows ([SQL-002](../../sql/SQL-002.md), [SQL-006](../../sql/SQL-006.md), [SQL-020](../../sql/SQL-020.md), [SQL-044](../../sql/SQL-044.md), [SQL-059](../../sql/SQL-059.md)).
- Enforces that the work-release date is valid at rule-check level two ([BR-004](../../business-rules.md#br-004-work-release-date-must-be-valid-at-level-two)) and that work-release status data is present ([BR-005](../../business-rules.md#br-005-work-release-status-data-must-be-present)).

## Context
- Namespace: `SAIF.Business.Claim`
- Assembly/package: `SAIF.Business.Claim.dll`

## Public members
| Member | Signature | Purpose |
| --- | --- | --- |
| `Criteria.RetrieveSQL` | `ReadOnly Property RetrieveSQL As String` | Retrieves only the latest work-release-status row via a correlated `max(seq)` subquery ([SQL-020](../../sql/SQL-020.md)). |
| `ValidWorkReleaseDate` | `Public Function ValidWorkReleaseDate() As Boolean` | Enforces [BR-004](../../business-rules.md#br-004-work-release-date-must-be-valid-at-level-two) at `RuleCheckLevel.LevelTwo`. |
| `HasData` | `Public Function HasData() As Boolean` | Enforces [BR-005](../../business-rules.md#br-005-work-release-status-data-must-be-present). |

## Behavioral notes
- DB-contention errors are raised via `After*` hooks on insert/update/delete ([BR-012](../../business-rules.md#br-012-optimistic-concurrency-contention-check)).

## Constraints and usage notes
- Only the most recent work-release-status row per claim is retrievable through this object; full history requires a separate query.

> **Note:** Statements marked with * were inferred from code structure, naming conventions, or
> contextual evidence where direct confirmation was not available in source artifacts. Statements
> marked with ** could not be confirmed; treat as unknown until verified.

## Related documentation
- [Library index](../../index.md)
- [API reference index](../index.md)
- [Overview](../../overview.md)
- [Architecture](../../architecture.md)
- [Dependencies](../../dependencies.md)
- [Operations and processes](../../operations-processes.md)
- [Business rules](../../business-rules.md)
- [Database tables](../../database-tables.md)
- [SQL catalog](../../sql/index.md)
## Sources
- SAIF.Business.Claim/clsClaimWorkReleaseStatus.vb